Brief Full Advanced Search Search Tips
|  |  | To access the contents, click the chapter and section titles. Visual Basic 6 Programming Blue Book: The Most Complete, Hands-On Resource for Writing Programs with Microsoft Visual Basic 6! (Publisher: The Coriolis Group) Author(s): Peter G. Aitken ISBN: 1576102815 Publication Date: 08/01/98 Search this book:
Previous | Table of Contents | Next
## Index Symbols & (ampersand) access key specifier, 53 long type declaration character, 67 string concatenation operator, 81 * (asterisk) multiplication operator, 59, 80 wildcard character, 370 @ (at sign) currency type declaration character, 67 \ (backslash) integer division, 80 ^ (caret) exponentiation operator, 80 , (comma) field delimiter, 351 location of Print # statement, 353–355 “ (double quotation mark) field delimiter, 351 E+ characters, format specifier, 111 = (equal sign) assignment operator, 58 “equal to” comparison operator, 83 ! (exclamation point) single type declaration character, 67 > “greater than” comparison operator, 83 >= “greater than or equal to” comparison operator, 83 < “less than” comparison operator, 83 <= “less than or equal to” comparison operator, 83 - (minus sign) subtraction operator, 80 <> “not equal to” comparison operator, 83 % (percent sign) integer type declaration character, 67 + (plus sign) addition operator, 80 string concatenation operator, Basic, 81 # (pound sign) double type declaration character, 67 format specifier, 111 ? (question mark) wildcard character, 370 ; (semicolon) location of Print # statement, 353–355 Print method modifier, 335 / (slash) division operator, 80 _ (space+underscore) line continuation character, 85 0 (zero character) format specifier, 111 A Abs function, 111 Absolute coordinates, 332 Accessing Windows API, 666–668 Access keys, menu items, 267 AccessType property, 486 Activating OLE objects, 241 ActiveForm property, 298 ActiveX, 183–197 class module, 184–185 and client/server applications, 622–623 project types, 134 vs. DDE, 201 ActiveX class, 185 ActiveX client, 185 ActiveX component, 136 ActiveX control events, 445–448 ActiveX Control Lister (ACLIST), 461–462 ActiveX controls, 8–9, 47–48, 159, 438–462 See also Custom controls. adding a property page, 454–458 adding properties, 452–453 compiling, 458–459 creating, 439–443 distributing, 460 project type, 134 responding to events, 448–452 running at design time, 444–445 testing, 443 testing options, 452 using in other projects, 459–460 using on the Web, 460–462 ActiveX Data Objects. See ADO. ActiveX DLL project type, 134 ActiveX DLLs (Dynamic Link Libraries), 623 ActiveX Document DLL project type, 134 ActiveX Document EXE project type, 134 ActiveX EXE, 623 creating, 196–197 project type, 134 ActiveX object, 185 ActiveX server, 185–196 ActiveX server types, 623–624 Adding buttons to Toolbars, 579–581 Command Buttons, 29, 103–105 images to ImageList control, 160–161 Label controls, 24–25 menus, 266–269 property procedures, 189 Addin project type, 134 Addition operator (+), 80 Additive primary colors, 325 AddNew method, 519 ADDRESS demonstration project, 493–507 adding a basic module, 496–497 chameleon command buttons, 498–502 designing the form, 494–496 initializing the program, 502–505 List form, 506–507 planning the database, 493–494 using multiple forms, 497–498 Adjusting. See Changing. ADO (ActiveX Data Objects), 532–533, 534 Data control, 533, 547 and data-aware controls, 548 error numbers, 598 model, 545–547 in designing a relational database application, 551–555 objects, 545–547 ADO Data control, 603 ADO Data control properties, 603 Algebraic logic, 95–96 Alias for DLL procedures, 668 Alias keyword, 668 Align command, 44 Aligning controls, 44–45, 46 text, 670–671 Alignment setting, 102 Align property, 575 ALIGNTXT demonstration project, 670–675 AllowCustomize property, 576 AllowZeroLength property, 566 And (logical operator), 84 Animations, simple, creating, 318–321 ANSI, 357 ANSI codes, 596 API (Applications Programming Interface), 533 See also Windows API. Text Viewer, 416 Applications decision-support, 542 deploying, 661–663 packaging, 659–661 transaction-processing, 542–543 Applications framework, 6–7 Applications Programming Interface. See API. Application Wizard, 128–129, 134 Apply button, property page, 456 ApplyChanges event, 457 Architecture centralized, 618 file server, 618, 620 Arguments, 110 Arithmetic operators, 80–82 Array index, 72 Arrays, 72–76 ASCII codes, 596 ASCII files, 264, 357 Assigning unused error number, 641–642 Assignment operator (=), 58, 79 Asterisk (*), multiplication operator, 59, 80 Asynchronous communications ports, 400 AtEndOfLine property, 358 AtEndOfStream property, 358 Atomic data, 553–554 Attribute classes, 538 Attributes property, 382–384 AutoActivate property, 241 AutoEnable property, 427 Automatic link update, 202 Automatic object references, 307 Automation Manager, 625 AutoRedraw property, 304 AvailableSpace property, 375 B Baby Editor project, 263–289 code writing, 271–289 planning, 264–265 visual design, 265–270 BackColor property, 43, 337 Back end, 530 BackStyle property, 337 .BAS file extension, 39 Basic modules, adding to database programs, 496–497 Basic procedure, 32–33 Basic statements. See Statements. Baud rate, 403 Baud rate parameter, 400 Binary access files, 345 Binary access mode, when to use, 367–368 Binary files reading and writing data, 365–367 using, 364–367 Binary search algorithm, 540 Binding, 548 Bitmap image format, 309 Bitmap pictures, displaying, 324 .BMP file extension, 309 Bookmark property, 522 Boolean data type, 83 Boolean variable, 102 Boolean variable type, 68, 70 BorderColor property, 337 BorderStyle property, 43, 102, 302, 337 BorderWidth property, 337 Bound, 548 BoundText properties, 603 Break mode, 650 and callback function, 677 and Immediate window, 655 Breakpoints, 649–650 Bugs, 648 Built-in collections, 157–159 Business rules, 620–621 ButtonClick event, 429, 580 ButtonCompleted event, 429–430 ButtonEnabled property, 427 ButtonGotFocus event, 429 ButtonHeight property, 576 ButtonLostFocus event, 429 Button object properties, 578–579 Button property, 575 Buttons collection, 576–577 Buttons tab, 575–576, 577–579 ButtonWidth property, 576 Byte numeric variable type, 64–65 Byte variable type, 68 C Calculator project, 95–124 creating the calculator, 100–119 enhancing the calculator, 119–124 planning, 95–100 visual interface, 102–105 writing the code, 105–124 Callback API function, 675–680 Callback demonstration project, 678–680 Callback function, 417 Callback function and break mode, 677 Call statement, 666–667 CanEject property, 427 CanPlay property, 427 CanRecord property, 427 CanStep property, 427 Capability command, 420 Caption property, 26, 29, 43, 52–53, 499, 578 Captions, changing, 29 CausesValidation property, 571–572, 597 Centralized architecture, 618 Changed property, 456–457 Change event, 35, 386–387 Changing to another drive, 371 to another folder, 371 button fonts, 104–105 captions, 29 Font property, 51 form position, 42–44 form size, 29, 42–44 multiple controls, 45 position of controls, 43–45 properties, 26, 42–43 shape of controls, 24–25 size of controls, 24–25, 43–45, 46, 58–59 text properties, 49–51 value of any variables and properties, 655 ChDir statement, 371 ChDrive statement, 371 Check Box control, 47, 549 Checked property, 270 Child forms, MDI, 295–296, 574–575 Child nodes, 162 Chr$ function, 279, 596 Circle method, 306–307, 329–330 CIRCLES demonstration project, 330 Class Builder utility, 139–147 Classes, 7, 138–151 See also Components; Objects. Collection, 153–159 demonstration project, 139–147 FileSystemObject (FSO), 355–359 OLE object, 229–230 relationship to objects, 139 Class_Initialize procedure, 190 Class Module Builder dialog box, 139–140 Class modules, 184–185 properties, 186–187 Class property, 230 Class_Terminate procedure, 190 Click event, 217, 314 Client, 530 Client application, 229 Client registration utility, 624 Client/server architecture, 620 Client/server databases, 543 Client/server models, 619–622 Client/server programming, 617–627 Clipboard copying to, 123 and creating DDE links, 206–209 data formats, 207 Clipboard.GetText, 274 Clipboard object, 123, 207–209, 273–275 Clipboard.SetText, 274 Close command, 415 Close method, 359 Close statement, 348 Closing, files, 348 .CLS file extension, 187 Code Basic, 14 connecting to the interface, 33–36 viewing, 33, 35 writing, 31–33 Code editing mode, 31 Code Editing window, 33, 35 Code module, 29 Codes module level, 108, 127 procedure level, 108, 127 CollatingOrder property, 567 Collection class, 153–159 Collection object, creating, 154 Collections built-in, 157–159 Buttons, 576–577 ColumnHeaders, 179–180 Columns, 550 Controls, 157–158 Drives, 375–377 Errors, 546 Fields, 546 Folders, 375 Forms, 157–158 ListImages, 160 ListItems, 178 Nodes, 162–163 Parameters, 546 Printers, 157, 341 Properties, 546 SelectedControls, 456 Colors dithering, 329 inverting, 324 RGB function, 325–329 RGB values, 324 specifying, 325 text, 54, 57–58 COLORS demonstration project, 326–329 ColumnHeaders collection, 179–180 Column property, 358 Columns collection, 550 Combo Box control, 47, 549, 584–586 COM (Component Object Model), 184 and client/server applications, 622–623 interfaces, 532 ComEvEOF event constant, 406 ComEvReceive event constant, 406 ComEvRing event constant, 406 ComEvSend event constant, 406 Command argument, to DDE source application, 220 Command Button control, 23, 46 Command buttons adding, 29, 103–105 chameleon, in a database program, 498–502 Command object, 532, 545 Command property, 427 Commands Align, 44 Capability, 420 Close, 415 Components, 135–137 GET, 470–471 HEAD, 470 MCI, 414–416 MCI button, 428–429 modem, 409 Paste Link, 209–213 Paste Special, 235–236 POST, 470 PUT, 470 References, 137–138 Seek, 419 sending to another program, 220 Step, 656 Comm control, 401–409 properties, 402–405 COMMDEMO demonstration project, 406–409 Comments, 77 CommEvent property, 405 Common controls, Windows, 159–181 Common Dialog controls, 277–281 opening files, 278–281 Printers, 341 selecting fonts, 287–289 ShowSave method, 283 CommPort property, 403 Communication control. See Comm control. Communication events, 406 Comparison expression, 87 Comparison operators, 83–84, 85 Compiling, 125–127 ActiveX controls, 458–459 to Native-code, 126–127 to P-code, 126 Component Object Model. See COM. Components, 7–9, 133–151 See also Classes; Objects. availability, 137–138 exposed, 135 registering, 196 types, 136–137 Components command, 135–137 COM ports, 400 Compound keys, 554 Compound primary keys, 538 Concatenation operator, 80–81 Connection object, 532, 545 ConnectionString property, 611 Connection string syntax, 611 Constants, 64, 76–77, 100–102 global, related to DDE, 208 intrinsic, 161 to test for buttons and shift keys, 314–315 Container applications OLE terminology, 229–233 Container property, 299 Context and watch expressions, 653–654 Control arrays, 119 Index argument, 103, 106 Control component, 136 Control names, referring to a different form, 525 Controls, 9, 22 ActiveX, 8–9, 47–48, 159, 438–462, 458–459 (See also Controls/custom) adding labels, 24–25 ADO Data, 533, 547, 548, 603 aligning, 44–45, 46 available, 48 binding to the data table, 518–519 changing position, 43–45 changing properties, 26 changing shapes, 24–25 changing size, 24–25, 43–45, 46, 58–59 Check Box, 47, 549 Combo Box, 47, 549, 584–586 Comm, 401–409 Command Button, 23, 29, 46 Common Dialog, 277–281, 283, 287–289, 341 as containers, 300 custom, 8–9, 47–48 (See also Controls/ActiveX) Data, 509–511 Data-aware, 510–511, 548–550 Data-bound, 510 DataCombo, 550 DataGrid, 549–550, 586 DataList, 550, 603–606 deleting, 43 DirListBox, 386 DriveListBox, 387 Enterprise Edition, 135 FileListBox, 384–385 file-related, 384–397 fixed-sized, 302 Frame, 51–52 Image, 318, 319, 549 ImageList, 160–161 Label, 23, 24–25, 47, 549 Line, 336–337 List Box, 47, 549 ListView, 178–181 locking, 46 MaskedEdit, 549 MSComm (See Controls/Comm) Multimedia, 426–434 multiple selected, dealing with, 456 names, 42 OCX, 438 OCX files, 137 OLE, 549 OLE container, 232 Option Button, 47 overlapped, 45–46 Picture Box, 47, 308–318, 549 PictureClip, 321–324 placement on forms, 41–42 Printers Common Dialog, 341 RemoteData, 534 RichTextBox, 549 selecting, 43 setting size and positions, 301 Shape, 337 TabStrip, 173–177 Text Box, 23, 26–29, 47, 549 Timer, 320, 422 TreeView, 161–173 WebBrowser, 487–488 Controls collection, 157–158 Conversations, DDE, 201–202 Coordinates, 332–333 Coordinate system, 295–296 CopyFolder method, 377 COPYLINK demonstration project, 216–218 Copy method, 377, 383 Counter numeric variable, 88–89 CreateEmbed method, 237–238 CreateLink method, 237–238 Creating ActiveX controls, 439–443 ActiveX EXE programs, 196–197 classes, 138–139 collection objects, 154 embedded objects, 237–238 executable files, 124–127 file objects, 381–382 folders, 371 MDI forms, 574 multipage dialog boxes, 173–177 objects, 148–149 procedures, 109–112 Setup programs, 657–658 simple animations, 318–321 toolbars, 574 CRLF (carriage return line feed) combination, 279–280 field delimiter, 351 CurDir function, 371 .CUR file extension, 309 Currency numeric variable type, 64–65 CurrentX property, 332–333 CurrentY property, 332–333 Cursor, 530 image format, 309 Custom controls, 8–9, 47–48 See also ActiveX controls. Common Dialog, 277–281 Custom coordinates, defining, 305–308 CVErr function, 643–644 D DAO (Data Access Objects), 533–534 Data atomic, 553–554 sending to another program, 220–221 Data Access Objects. See DAO. Data arrays, 119 Data-aware controls, 510–511, 548–550 Database development tools, 545–550 Database engine errors, using, 597–598 Database management system. See DBMS. DatabaseName property, 518 Database programming terminology, 538–539 Database programs, initializing, 502–505 Databases accessing without ADO Data control, 547 client/server, 543 creating at runtime, 548 creating using Visual Data Manager, 511–516 defined, 492 development of, advantages of Visual Basic, 544 flat file, 536 front end applications, 541–543 legacy, 544 multiuser, 619 relational, 536–540 relational, designing the application, 551–555 relational vs. flat file, 536–538 supported file formats, 508 validation methods, 595–599 Database tables defining the structure, 514 extracting information, 541 modifying, 515 Database terminology, 529–534 Database tools, 507–527 Data-bound controls, 510 DataCombo control, 550 Data control, 509–511 ADO, 533 DataField property, 518, 548 DataGrid control, 549–550, 586 DataList control, 550, 603–606 Data loss, preventing, 276–277 Data object model, 545–547 Data Project, 134 Data source, 530 DataSource property, 518, 548 DataUpdatable property, 567 DateCreated property, 378, 383 DateLastAccessed property, 378, 383 DateLastModified property, 378, 383 Date variable type, 68, 70 DBMS (Database management system), 619–620 DCOM (Distributed Component Object Model), 623 DDE conversation, 201–202 DDE (Dynamic Data Exchange), 199–225 and objects, 202–204 terminology, 201–202 transferring data, 219–225 vs. ActiveX, 201 vs. OLE, 201, 231–232 DDE events, 204–206 DDE links, 200–202, 207–218 information, 207–209 copying to Clipboard, 215–216 initiating, 203–204 updating, 202 using Clipboard, 206–209 Debugging programs, 647–656 controlling execution during, 656 Debug menu, 656 Debug.Print method, 99, 119 Debug.Print statement, 649 Decision structures, 85–87 Decision-support applications, 542 Declare statement, 667–669 keyword components, 668–669 Declaring API functions as procedures, 669–670 constants, 100–102 public variables, 100–102 variables, 67–70, 187 DefaultValue property, 567 Deferring error trapping, 639–640 Delete method, 378, 383, 519 Deleting files, 370 folders, 370 Demonstration projects ActiveX server, 185–196 ADDRESS, 493–507 Baby Editor, 263–289 Calculator, 95–124 callback, 678–680 CIRCLES, 330 classes, 139–147 COLORS, 326–329 COMMDEMO, 406–409 COPYLINK, 216–218 DRIVESDEMO, 376–377 FancyCmdButton, 439–460 FINDFILE, 387–397 FOLDERDEMO, 378–381 FRONTEND, 221–225 FSODEMO, 359–361 GRAPEVINE, 556–563 ITC_DEMO, 471–475 mortgage calculator, 22–36 MUSIC, 511–527 OLE automation with embedded objects, 255–259 OLE automation with nonembedded objects, 253–255 OLE container application, 242–248 PAINTPIC, 312–318 Paste Link, 209–213 PICTURECLIP, 322–324 PICTUREDEMO, 318–321 Playing with Properties, 49–60 PRINT1, 339–340 Screen display, 300–302 SOUND1, 421–425 SOUND2, 431–434 SuperString class, 147–151 Text box project, 49–60 TreeView control, 167–173 Windows API, 670–675 Dependent tables, 539 Deploying your applications, 661–663 Description property, 578 Designer, 49 Designer component, 136 Design grid, 44 Design-time, 10 Destination application, 201–202, 229 Destination control properties, 202–204 DHTML application, 134 Dialog boxes, New Project, 18, 38–39 .DIB file extension, 309 Dim keyword, 497 Dim statement, 67, 127, 148 Directory List Box, 386 Dir function, 373 DirListBox control, 386 Disabling menu items, 275–276 DISPLAY_FORMAT constants, 101 DisplayHasData flag, 107 Displaying bitmap pictures, 324 events associated with forms, 303–304 metafile pictures, 324 text, 334–336 DisplayResult procedure, 109–112 Distributed Component Object Model. See DCOM. Distributing programs, 656–663 Dithering colors, 329 Division operator (/), 80 DLL files, 136 DLL procedure alias, 668 DLL procedure names, 668 DLLs (Dynamic link libraries), 666 Document property, 486 Do...Loop, 89–91 Done event, 430 Double numeric variable type, 64–65 Drag-and-drop inserting objects, 239 DragDrop event, 428 DragOver event, 428 DrawMode property, 333–334, 337 DrawStyle property, 333 DriveLetter property, 375 DriveListBox control, 387 Drive object, 374–377 Drive object properties, 375–376 Drive property, 378, 383, 387 Drives collection, 375–377 DRIVESDEMO demonstration project, 376–377 DriveType property, 375 DropHighlight property, 165 Dynamic arrays, 75–76 Dynamic Data Exchange. See DDE. Dynamic link libraries (DLLs). See DLLs. Dynaset-type Recordset, 520–521 E Early binding, 148 Elseif keyword, 86 Else keyword, 86 Embedded objects, creating, 237–238 .EMF file extension, 309 Empty value, 98 Enabled property, 270, 275, 427, 576, 578 Enabling menu items, 275–276 Encapsulation, 143 End of file detection, 280, 352–353 End statement, 34, 56–57, 501 Enterprise Edition controls, 135 Entity, 538 Entity class, 538 Entity occurrences, 538 Enum...End Enum statement, 78, 252 Enums, 78–79, 252 EnumWindows API function, 676 EnumWindows API procedure, 678–679 EOF function, 280, 352–353 Eqv (logical operator), 84 ERR object, 636–639, 640 ERR object properties, 636–639 Error-handling codes, 644–645 ErrorMessage property, 431 Error number, assigning unused, 641–642 Error object, 546 Error property, 431 Errors raising, 640–641 returning from functions, 643–644 runtime, handling, 631–645 syntax, 631–632 trapping, 633–635 user-defined, 641–644 Errors, ITC, 471 Errors collection, 546 Error trapping, deferring, 639–640 Error value, 98 Event detection, 12, 22 Event-driven communication, 402 Event-driven programming, 10 Event handler. See Event-handling procedures. Event-handling procedures, 12–13, 34, 35–36, 56–59 See also Events. names, 12, 35–36, 57 Event procedures. See Event-handling procedures; Events. Events, 10–13 See also Event-handling procedures. ActiveX control, 445–448 ApplyChanges, 457 associated with loading, showing, sizing and unloading forms, 304 ButtonClick, 429, 580 ButtonCompleted, 429–430 ButtonGotFocus, 429 ButtonLostFocus, 429 Change, 35, 386–387 Click, 217, 314 communication, 406 DDE, 204–206 Done, 430 DragDrop, 428 DragOver, 428 FileListBox, 385 Form_Resize, 272, 301–302 icResponseCompleted, 469–470 icResponseReceived, 469–470 Initialize, 147, 447 InitProperties, 447 KeyPress, 596 LinkClose, 205 LinkError, 205 LinkExecute, 206 LinkNotify, 205 LinkOpen, 204–205 Load, 300, 506 LostFocus, 597 MouseDown, 313–314 MouseUp, 314 Multimedia control, 428–430 OnComm, 405–406 Paint, 304, 447 PathChange, 385 PlayCompleted, 429 QueryUnload, 501 ReadProperties, 447 Resize, 447 SelectionChanged, 455 StateChanged, 466–468 StatusUpdate, 430 Terminate, 447 Unload, 501 Validate, 571–573, 597, 600 WriteProperties, 447 Execute method, 470–471, 476–478 EXEName property, 214 Exit For statement, 89 Exponentiation operator (^), 80 Exposed components, 135 Expression, 80 F FancyCmdButton demonstration project, 439–460 Field object, 545 Field properties, 565–569 Fields, 538 database, 492 repeating, 558–560 in sequential files, 349–352 Fields collection, 546 File access modes, when to use, 367–368 types, 344–346 FileAttr function, 373–374 File extensions .BAS, 39 .BMP, 309 .CLS, 187 .CUR, 309 .DIB, 309 .DLL, 136 .EMF, 309 .FRM, 39 .GIF, 309 .ICO, 309 .JPEG, 309 .JPG, 309 .OCX, 48, 136 .TXT, 264 .VBP, 40 .WMF, 309 FileListBox control, 384–385 FileListBox events, 385 File management statements, 370–374 Filename property, 385 File numbers, 346–348 File objects, 374, 381–384 File pointer, 364–365 File position, 364–365 File-related controls, 384–397 demonstration project, 387–397 Files closing, 348 deleting, 370 executable, creating, 124–127 finding, 373–374 new, starting, 281–282 opening, 278–281, 346 saving, 282–287 Files collection, 375, 377, 382 File server architecture, 618, 620 Files property, 378 FileSystemObject (FSO), 355–359 FileSystem property, 375 File Transfer Protocol. See FTP. File types restricting listing, 278 FillColor property, 337 FillStyle property, 337 Filter property, 278–279 FINDFILE demonstration project, 387–397 creating the form, 388–390 exploring the recursive algorithm, 395–397 writing the code, 390–395 FindFirst method, 522 FindLast method, 522 FindNext method, 522 FindRecord procedure, 521–522 Fixed-length strings, 69 Fixed-sized controls, 302 Flags, 83, 102 DisplayHasData, 107 Flags property, selecting fonts, 287 Flat file databases, 536 Floating point numbers, 64–65 FOLDERDEMO demonstration project, 378–381 Folder object, 374–375, 377–381 properties, 378 Folders creating, 371 deleting, 370 Folders collection, 375 Font property, 51, 104–105 Fonts changing properties, 51 selecting, 287–289 For Each...Next statement, 156 ForeColor property, 43, 54, 57–58 Foreign keys, 539 Format function, 111 Format specifier string, 111 Form design mode, 31 Form Design window, 20 Form Editor toolbar, 46 Form Grid Settings, 44 Form Layout window, 21 Form_Load events Baby Editor project, 271–272 Form module, 39 Form_Resize events, 272, 301–302 Forms, 9, 22 See also Windows (screen); individual form names. adding to an existing project, 290 adjusting sizes, 29 changing caption, 29 changing size and position, 42–44 controls placement, 41–42 displaying associated events, 303–304 hiding, 291 loading associated events, 303–304 MDI, 574–575 multiple, 289–293 non-MDI, 574 Picture Box, multiple, 574–575 properties, 42–43 saving, 30 Forms collection, 157–158 For...Next loop, 88–89, 306 Frame control, 51–52 Frame objects, 176–177 Framework, applications, 6–7 FreeSpace property, 375 .FRM file extension, 39 Front end. See Client. FRONTEND demonstration project, 221–225 FSODEMO demonstration project, 359–361 FSO file management, 374–384 FSO text file access, 355–359 FTP_DEMO demonstration project, 478–486 FTP (File Transfer Protocol), 464, 475–487 commands, 477–478 FTP Logons, 475–476 Full-module view, 35 Function pointer, 676 Function procedures, 284–285 Functions, 108–109 callback, 675–680 Callback, 417 Chr$, 279, 596 CurDir, 371 CVErr, 643–644 EOF, 280, 352–353 FileAttr, 373–374 InputBox, 522 QBColor, 325 Seek, 364–365 string processing, 293 G General Button tab, 575–576 General error-handling code, 644–645 General procedures. See Procedures. GetChunk method, 468–470, 477 GetClassName API function, 678 GET command, 470–471 GetFile method, 381 GetFormat method, 207–208 Get statement, 363–364, 365 GetText method, 108 GetWindowsText API function, 678 GetWindowTextLength API function, 679 .GIF file extension, 309 Global keyword, 128 Global variables. See Public variables. GRAPEVINE demonstration project, 556–563, 567–593, 598–616 completing the Invoices form, 613–615 connecting to the Invoices table, 610–613 connecting to the Items table, 606–607 creating the database, 560–563 data validation, 598–601 designing tables, 557–558 designing the Customers form, 581–584 designing the List form, 586 designing the Wines form, 584–586 entering orders, 601–602 fundamental program structure, 573–574 Invoices form, 601–606 preliminary form design, 574–586 repeating fields, 558–560 Select Wine form, 607–610 setting field properties, 567–569 writing the code, 586–593 Grid of cells, 549 H Handles, 24, 42 HEAD command, 470 Height property, 298–299 Hide method, 291, 303 HTML (Hypertext Markup Language), 464–465 HTTP (Hypertext Transfer Protocol), defined, 464–465 Hungarian notation, 66 Hypertext Markup Language. See HTML. Hypertext Transfer Protocol. See HTTP. I .ICO file extension, 309 Icon image format, 309 Icons, choosing, 125 Icon view (ListView control), 178–179 IcResponseCompleted event, 469–470 IcResponseReceived event, 469–470 If structure, 85–86 IIS Application, 134 Image control, 318, 549 vs. Picture Box control, 319 ImageList control, 160–161 ImageList property, 576 Image property, 578 Images. See also Pictures. composite, storing, 321–324 creating from scratch, 324–325 displaying at nodes, 164 drawing, 324–325 formats for Picture Box, 309 storing, 318–321 Immediate window, 655–656 Imp (logical operator), 84 InBufferCount property, 404 InBufferSize property, 404 Index definition, 514 Indexes (database), 539 defining, 569–571 Index property, 164, 165–166 Infinite loop, 92 Initialization procedure, 190 Initialize event, 447 Initialize event procedure, 147 Initiating DDE links, 203–204 InitProperties event, 447 In-place activation OLE object, 232 In-process servers, 623 InputBox function, 522 Input buffer (Comm control), 404–405 InputLen property, 404 Input property, 404–405 Input # statement, 350–352 Insertable Object component, 136–137 Insertable objects, 29, 48–49 Inserting, OLE objects, 233–236 Insert method, 145–146 InsertObjDlg method, 238 Insert procedure, 143 Instancing MultiUse property, 186 Instr function, 115 Integer division, 80 Integer numbers, 64–65 Integer numeric variable type, 64–65 Integer variable (stack pointer), 99 Integrity, referential, 571 Interface ActiveX, 185 visual, 22 Internet programming, 463–464 Internet Transfer Control. See ITC. Interval property, 320 Intrinsic constants, 161 IsReady property, 376 IsRootFolder property, 378 ITC_DEMO demonstration project, 471–475 ITC (Internet Transfer Control), 464–487 error types, 471 for HTTP, 464–475 for HTTP transfers, 471–475 properties, 486–487 using for FTP, 475–487 Item (DDE conversation), 201–202 J Jet database engine, 508, 509, 511 Joins, 541 JPEG image format, 309 .JPG file extension, 309 JustLoaded flag, 277 K Key field, primary, 554 KeyPress event, 596 Key property, 578 Keys compound, 554 compound primary, 538 foreign, 539 primary, 538–539, 552 surrogate, 554 Keystrokes, blocking, 596 Keywords Alias, 668 Dim, 497 Private, 668–669 Public, 497, 668–669 Kill statement, 370 L Label control, 23, 24–25, 47, 549 adding, 24–25 Late binding, 148–149 Left property, 298 Legacy databases, 544 Length property, 145–146 Line continuation character, 85 Line control, 336–337 Line Input statement, 279 Line method, 324–329 Line property, 358 Line wrapping, 85, 335–336 LinkClose event, 205 LinkError event, 205 LinkExecute event, 206 LinkExecute method, 220 LinkItem property, 202–203 LinkMode property, 202–204, 217 LinkNotify event, 205 LinkOpen event, 204–205 LinkPoke method, 221 Links DDE, 200–202 pasting from a program, 214–215 pasting into a program, 206–213 LinkTimeout property, 203 LinkTopic property, 202–204 Link update, automatic, 202 List Box control, 47, 549 List form (database program), 506–507 ListImages collection, 160 ListItem object, 178 ListItems collection, 178 ListView control, 178–181 Literal constants, 76–77 Load event, 300, 506 Loading forms, associated events, 303–304 pictures during program design, 308–309 pictures during program execution, 309–310 Load statement, 303 Loc function, 364–365 Locked property, 102 Locking controls, 46 Logical expressions, 82–83, 85 Logical operators, 84–85 Logical units, 296 Long numeric variable type, 64–65 Loops and arrays, 119 Infinite, 92 nested, 91–92 Loop structures, 88–93 LostFocus event, 597 M Mainframes, 618 Main window, 19, 20, 21 Manual link update, 202 MaskColor property, 161 MaskedEdit control, 549 Matrix of cells, 549 MCI button commands, 428–429 commands, 414–416 MCI (Media Control Interface), 413–434 MciSendString function, 416 MDI form, 574–575 MDI forms, creating, 574 MDI (Multiple Document Interface), 295–296, 574–575 Media Control Interface. See MCI. Me keyword, 291 Menu Editor, 266–270 Menus adding, 266–269 enabling and disabling items, 275–276 pop-up, 42 Messages displaying, 285 Windows, 11–12 Metafile image format, 309 Metafile pictures, displaying, 324 Methods ActiveX classes, 190–192 AddNew, 519 associated with objects, 10 Circle, 306–307, 329–330 Close, 359 Copy, 377, 383 CopyFolder, 377 CreateEmbed, 237–238 CreateLink, 237–238 Debug.Print, 99, 119 Delete, 378, 383, 519 Execute, 470–471, 476–478 FindFirst, 522 FindLast, 522 FindNext, 522 GetChunk, 468–470, 477 GetFile, 381 GetFormat, 207–208 GetText, 108 Hide, 291, 303 Insert, 145–146 InsertObjDlg, 238 Line, 324–329 LinkExecute, 220 LinkPoke, 221 MoveFolder, 377 OpenURL, 465–466, 476 Overlay, 161 Print, 334–336 PrintForm, 340 Pset, 330–332 Raise, 640–641 ReadAll, 359 ReadFromFile, 240 Read(n), 359 Recordset, 521 RecordSet object, 587–588 SaveToFile, 240 Scale, 305–306 SetData, 215 SetText, 215–216 Show, 291, 303, 500, 506 ShowOpen, 279 ShowSave, 283 SkipLine, 359 Skip(n), 359 TextStream object, 359 Update, 240–241 WriteBlankLines(n), 359 WriteLine(s), 359 Write(s), 359 Microsoft Internet Explorer, 443 Microsoft Scripting Runtime, 356 MinButton property, 102 MixedState property, 578 MkDir statement, 371 MMControl, 429 Modem commands, 409 Modems and serial ports, 401 Mode property, 427 Modes code editing, 31 form design, 31 Mod (modulus operator), 80 Module level code, 108, 127 Modules, 20, 39–40, 252 code, 39 form, 39 naming, 40 saving, 39–40 Modulus operator (Mod), 80 Mortgage calculator project, 22–36 code writing, 31–33 connecting the code to the interface, 33–36 visual interface design, 24–30 MouseDown event, 313–314 MousePointer property, 43, 297–298, 576 MouseUp event, 314 MoveFolder method, 377 Move method, 377, 383 MoveNext method, 519 MPC (Multimedia PC) standard, 412–413 MSComm control. See Comm control. MsgBox function, 117, 285–286 flags argument, 285–286 MultiLine property, 102 Multimedia defined, 412 devices, 413 errors, 421 Multimedia control, 426–434 errors, 431 events, 428–430 properties, 427–428 Multimedia errors, 421 Multimedia PC. See MPC. Multimedia sound, 414 Multiple Document Interface. See MDI. Multiple forms, 289–293 in database programs, 497–498 Multiple selected controls, dealing with, 456 Multiple-tier client/server models, 621–622 Multiplication operator (*), 59, 80 Multitable select, 541 Multiuser databases, 619 MUSIC demonstration project, 511–527 binding controls to the data table, 518–519 designing the main form, 516–518 using Visual Data Manager, 511–516 MvarLength variable, 142 MvarValue variable, 142 N Name AXDEMO property, 187 Name property, 27–29, 53, 215, 378, 383 controls, 42 menu items, 267 modules, 40 Name statement, 373 Naming enumeration members, 79 event-handling procedures, 57 modules, 40 variables, 65–67 Native-code, compiling to, 126–127 Nested loop, 91–92 Network OLE, 623 NewEntry Boolean variable, 106 New files, starting, 281–282 New Project dialog box, 18, 38–39 Node object, 162–166 Nodes, 164–166 Nodes collection, 162–163 NoMatch property, 522 Non-MDI form, 574 Notify link update, 202 Notify property, 430 NotifyValue property, 430 Not (logical operator), 84 Null modem, 400 Null value (Variant variable type), 98 Numeric variables, 64–65 O Object, data unit using OLE, 229 Object Browser, 193 object information, 250–253 Object Linking and Embedding. See OLE. Object-oriented file management, 374–384 Object-oriented programming (OOP), 8 Object references, automatic, 307 Objects, 7, 9–10 See also Class; Components; Forms. ADO (ActiveX Data Objects), 532–533, 534 available information, 250 Clipboard, 123, 207–209, 273–275 Collection, 154 Command, 532, 545 Connection, 532, 545 creating, 148–149 and DDE, 202–204 Drive, 374–377 embedded, creating, 237–238 ERR, 636–639, 640 Error, 546 Field, 545 File, 374, 381–384 Folder, 374–375, 377–381 Frame, 176–177 insertable, 29, 48–49 inserting with drag-and-drop, 239 kinds, 9 ListItem, 178 methods, 10 Node, 162–166 OLE, 233–236, 239–241 Parameter, 546 Picture, 318–321 creating simple animation, 318–321 Printer, 337–340 properties, 9–10, 20–21, 22 Property, 546 RecordSet, 587 Recordset, 518, 520–521, 545 relationship to classes, 139 screen, 297–298 TextStream, 356–359 UserControl, 439–440 viewing, 33 Object variable type, 70 OCX controls See ActiveX controls; Custom Controls. OCX files, 48, 136 ODBC (Open Database Connectivity), 533–534 OLE automation, 137, 248–259 with embedded objects demonstration project, 255–259 with nonembedded objects demonstration project, 253–255 OLE automation objects creating, 249–250 methods, 253 properties, 253 OLE container application demonstration project, 242–248 inserting objects, 233–236 OLE Container control, 232 OLE Control, 549 OLE DB, 532 OLE (Object Linking and Embedding), 184, 227–259, 437 terminology, 229–248 vs. DDE, 201, 231–232 OLE objects activating, 241 activation, 232 classes, 229–230 inserting, 233–236 retrieving, 240 saving, 239 OLE servers deleting, 233 uninstalling, 233 OLE Type, restricting, 235 OleTypeAllowed property, 235 OnComm event, 405–406 On Error Resume Next statement, 639–640 On Error statement, 633–635 On Local Error statement, 225 OOP (Object-oriented programming), 8 Opcode argument, PaintPicture method, 311 OpenAsTextStream method, 383 Open command, 415 Open Database Connectivity. See ODBC. Opening files, 278–281, 346 Open statement, 346 OpenURL method, 465–466, 476 Operators arithmetic, 80–82 assignment, 58 comparison, 83–84 logical, 84–85 precedence, 81–82 string manipulation, 80–81 Option Button control, 47 Option Explicit, 68 to avoid program bugs, 648 OrdinalPosition property, 566–567 Orientation property, 428 Or (logical operator), 84 OutBufferCount property, 404 OutBufferSize property, 404 Out-of-process servers, 623 Out of scope variable, 127 Output buffer (Comm control), 404–405 Outputlist argument (Print method), 334–335 Output property, 404 Overlapped controls, 45–46 Overlay method, 161 P Package and Deployment Wizard. See PD Wizard. Packaging your application, 659–661 Paint event, 304, 447 PAINTPIC demonstration project, 312–318 PaintPicture method, 310–318 Parameter object, 546 Parameters collection, 546 ParentFolder property, 378, 383 Parent forms, MDI, 295–296 Parent nodes, 162 Parity parameter, 401 Parity settings, 403 Password property, 475–476, 486 Paste Link command, 209–213 Paste Link demonstration project, 209–213 Paste Special command, 235–236, 238 PasteSpecialDlg method, 238 Path of current application, 372 current vs. application’s path, 372 determining on current drive, 371 relative vs. absolute, 382 PathChange event, 385 Path property, 372, 376, 378, 383, 385, 386 PatternChange property, 385 Pattern property, 385 P-code, compiling to, 126 PD Wizard (Package and Deployment Wizard), 658–663 Picture Box control, 47, 308–318, 549 vs. Image control, 319 Picture Box forms, multiple, 574–575 PictureClip control, 321–324 PICTURECLIP demonstration project, 322–324 PICTUREDEMO demonstration program, 318–321 Picture object, 318–321 Pictures See also Images. loading during program design, 308–309 loading during program execution, 309–310 Picture tab, 575–576 Pixel, 297 PlaceholderWidth property, 578 Play command, 415 PlayCompleted event, 429 Playing with Properties project adding code, 56–60 executing the program, 59–60 interface design, 49–55 Polling, 402 Pop-up menus, 42 Ports, serial, 400 POST command, 470 Preserve keyword, 75–76 Primary colors, 325 Primary keys, 538–539, 552 compound, 538 field, 554 Primary tables, 539 PRINT1 demonstration project, 339–340 Printer object, 337–340 Printers collection, 157, 341 Printers Common Dialog control, 341 PrintForm method, 340 Print method, 334–336 Print # statement, 353–355 Private keyword, 78, 109, 127, 668–669 Private variable declarations, 187 Procedure arguments, 108–110 Procedure level code, 108, 127 Procedures, 108–112, 119 Basic, 32–33 Class_Terminate, 190 creating, 109–112 DisplayResult, 109–112 event-handling, 12–13, 34, 35–36, 56–59 FindRecord, 521 function, 284–285 initialization, 190 Property Get, 143, 188 Property Let, 143, 188 Property Set, 188 SetTextAlign, 670–671 termination, 190 Procedure view, 35 Program design, inserting OLE objects, 234–235 Programmable data objects, 248 Programs See also Demonstration projects; Projects. debugging, 647–656 distributing, 656–663 exiting, 34 running, 33 Project Explorer window, 20 Project file, 40 Project icons, 125 Projects, 20 See also Demonstration projects; Programs. multiple forms, 289–293 saving, 30, 39–40 starting, 38–39 types, 133–135 Properties, 49–51, 52–55 AccessType, 486 ActiveForm, 298 ADO Data control, 603 Align, 575 AllowCustomize, 576 AllowZeroLength, 566 AtEndOfLine, 358 AtEndOfStream, 358 Attributes, 382–384 AutoActivate, 241 AutoEnable, 427 AutoRedraw, 304 AvailableSpace, 375 BackColor, 43, 337 BackStyle, 337 Bookmark, 522 BorderColor, 337 BorderStyle, 43, 102, 302, 337 BorderWidth, 337 BoundText, 603 Button, 575 ButtonEnabled, 427 ButtonHeight, 576 Button object, 578–579 ButtonWidth, 576 CanEject, 427 CanPlay, 427 CanRecord, 427 CanStep, 427 Caption, 26, 29, 43, 52–53, 499, 578 CausesValidation, 571–572, 597 Changed, 456–457 changing, 26, 42–43 changing values, 655 Checked, 270 Class, 230 CollatingOrder, 567 Column, 358 Command, 427 Comm control, 402–405 CommEvent, 405 CommPort, 403 Container, 299 CurrentX, 332–333 CurrentY, 332–333 DatabaseName, 518 DataField, 518, 548 DataSource, 518, 548 DataUpdatable, 567 DateCreated, 378, 383 DateLastAccessed, 378, 383 DateLastModified, 378, 383 DefaultValue, 567 Description, 578 determining position and size, 298–302 Document, 486 DrawMode, 333–334, 337 DrawStyle, 333 Drive, 378, 383, 387 DriveLetter, 375 DriveType, 375 DropHighlight, 165 Enabled, 270, 275, 427, 576, 578 ERR object, 636–639 Error, 431 ErrorMessage, 431 EXEName, 214 field, 565–569 Filename, 385 Files, 378 FileSystem, 375 FillColor, 337 FillStyle, 337 Filter, 278–279 Flags, 287 Font, 51, 104–105 fonts, changing, 51 ForeColor, 43, 54, 57–58 forms, 42–43 FreeSpace, 375 Height, 298–299 Image, 578 ImageList, 576 InBufferCount, 404 InBufferSize, 404 Index, 164, 165–166 InputLen, 404 Instancing MultiUse, 186 Interval, 320 IsReady, 376 IsRootFolder, 378 ITC (Internet Transfer Control), 486–487 Key, 578 Left, 298 Length, 145–146 Line, 358 LinkItem, 202–203 LinkMode, 202–204, 217 LinkTimeout, 203 LinkTopic, 202–204 MaskColor, 161 Menu Editor, 270 MixedState, 578 Mode, 427 MousePointer, 43, 297–298, 576 MultiLine, 102 Multimedia control, 427–428 Name, 27–29, 53, 378, 383 Name AXDEMO, 187 names, 27–29 NoMatch, 522 Notify, 430 NotifyValue, 430 of objects, 9–10, 20–21, 22 OLE automation object, 253 OrdinalPosition, 566–567 Orientation, 428 OutBufferCount, 404 OutBufferSize, 404 Output, 404 ParentFolder, 378, 383 Password, 475–476, 486 Path, 372, 376, 378, 383, 385, 386 Pattern, 385 PatternChange, 385 PlaceholderWidth, 578 Protocol, 486–487 Proxy, 487 RecordCount, 524 Recordset, 520–521 RecordsetType, 518 RecordSource, 518 RequestTimeout, 487 Required, 566 ResponseCode, 466–467, 487 ResponseInfo, 466–467, 487 RootFolder, 376 RThreshold, 406 ScaleHeight, 299 ScaleMode, 296, 298 ScaleWidth, 299 SelLength, 273 SelText, 273 SerialNumber, 376 setting, 52–55 Settings, 403 Shape, 337 ShareName, 376 ShortName, 378, 383 ShortPath, 378, 383 ShowTips, 576 Size, 378, 383 Sorted, 497 StillExecuting, 478, 487 Style, 578–579 SubFolders, 378 SubItems, 180 TabStrip, 174–176 Tag, 165, 215, 216–217, 578 Text, 27–28, 50–51 Threshold, 406 TimeFormat, 427–428 Toolbar Control, 575–576 ToolTipText, 578 Top, 298 TotalSize, 376 Type, 383 UpdateInterval, 430 UpdateOptions, 240–241 URL, 487 Username, 475–476, 487 validation, 566 ValidationOnSet, 566 ValidationRule, 566 ValidationText, 566 Value, 53, 144–145, 578 Visible, 270, 291, 578, 607 VolumeName, 376 Wait, 428 Width, 298–299 Wrappable, 576 Properties collection, 546 Properties window, 20–21, 25–26 Property Get procedure, 143, 188 Property Let procedure, 143, 188 Property object, 546 Property page adding to ActiveX controls, 454–458 Apply button, 456 Property procedures, 143–147, 187–188 adding to class modules, 189 Property Set procedures, 188 Protocol, 465 Protocol property, 486–487 Proxy property, 487 Pset method, 330–332 Public keyword, 78, 109, 128, 497, 668–669 Public variables, 100–102 PUT command, 470 Put statement, 362–364, 365 Q QBColor function, 325 Queries, 530, 540 QueryUnload event, 501 Quick watches, 654 R RACM (Remote Automation Connection Manager), 624–625 RaiseEvent statement, 449 Raise method, 640–641 Raising errors, 640–641 Random access files, 345, 361–364 defining record structure, 361–362 reading and writing, 362–364 Random access mode when to use, 368 RDO (Remote Data Objects), 534 ReadAll method, 359 ReadFromFile method, 240 Reading, data from random access files, 363–364 Read(n) method, 359 ReadProperties event, 447 Record, finding in database tables, 521–522 RecordCount property, 524 Records database, 492 listing from a database, 523–526 sorting in a relational database, 539–540 units of data, 344–345 Recordset method, 521 RecordSet object, 587 Recordset object, 518, 520–521, 545 RecordSet object methods, 587–588 Recordset property, 520–521 RecordsetType property, 518 Recordset types, 520–521 RecordSource property, 518 Record structure, defining random file, 361–362 ReDim, 75 References command, 137–138 References list, object information, 250–251 Referential integrity, 571 Registering components, 196 Registering servers, 624 Relational databases, 536–540 designing the application, 551–555 Relative coordinates, 332–333 Relative vs. absolute paths, 382 Remote Automation Connection Manager, 624–625 RemoteData control, 534 Remote Data Objects. See RDO. Report view (ListView control), 178 RequestTimeout property, 487 Required property, 566 Require Variable Declaration option, 67–68 Resize event, 447 ResponseCode property, 466–467, 487 ResponseInfo property, 466–467, 487 Resume statement, 635–636 Retrieving OLE objects, 240 Return data type, 284 Returning errors from functions, 643–644 Reverse Polish Notation (RPN), 95–97 RGB function, 325–329 RGB values, 334 RichTextBox control, 549 RmDir statement, 370 RootFolder property, 376 Root nodes, 162 RPN (Reverse Polish Notation), 95–97 RS-232 ports, 400 RThreshold property, 406 Runtime, 10 creating databases, 548 inserting objects using a dialog box, 238 inserting OLE objects, 236 Runtime errors, handling, 631–645 S SaveChanges function, 280 creating, 287 SaveToFile method, 240 Saving files, 282–287 forms, 30 modules, 39–40 OLE objects, 239 projects, 30, 39–40 ScaleHeight property, 299 Scale method, 305–306 ScaleMode property, 296, 298 Scales of coordinate systems, 296 ScaleWidth property, 299 Scope, 653 Screen display demonstration project, 300–302 Screen measurement unit, 41 Screen objects, 297–298 Screens Visual Basic, 38–39 Visual Data Manager, 511–512 Scripting qualifier, 356 Search algorithm, binary, 540 Seek command, 419 Seek function, 364–365 Seek statement, 364–365 Select Case structure, 87 SelectedControls collection, 456 SelectionChanged event, 455 Self-modifying programs, 10 SelLength property, 273 SelText property, 273 Sending commands to another program, 220 data to another program, 220–221 Separators adding to menus, 268 SEQUEL (Structured English Query Language), 530 Sequential access files, 344–345 Sequential access mode, when to use, 367–368 Sequential files fields, 349–352 text, 353–361 using, 348–349 Serial communication fundamentals, 399–400 parameters, 400–401 sending and receiving data, 404–405 SerialNumber property, 376 Serial ports, 400 determining status, 405 setting communication parameters, 403 Server, 530 Server applications OLE terminology, 229–233 Servers defined, 622 registering, 624 types, 623–624 Set command, 420 SetData method, 215 Set statement, 148 SetTextAlign API procedure, 669–670 SetTextAlign procedure, 670–671 SetText method, 215–216 Settings property, 403 Setup program, creating, 657–658 Shape control, 337 Shape property, 337 ShareName property, 376 Shell function, 219–220 ShortName property, 378, 383 ShortPath property, 378, 383 Show method, 291, 303, 500, 506 ShowOpen method, 279 ShowSave method, 283 ShowTips property, 576 Siblings nodes, 162 Single numeric variable type, 64–65 Single stepping the program, 656 Size property, 378, 383 SkipLine method, 359 Skip(n) method, 359 SmallIcon view (ListView control), 178–179 Snapshot type of Recordset, 520 Snap-to-grid feature, 25 Software components, 7–9 Sorted property, 497 Sorting logical, 539 records in a relational database, 539–540 SOUND1 demonstration project, 421–425 SOUND2 demonstration project, 431–434 Source application, 201–202, 229 SQL (Structured Query Language), 521, 530–531 Stack pointer (Integer variable), 99 Stacks, 96–97, 99, 116 STACKSIZE constant, 101 Standard EXE application, 134 Starting new files, 281–282 Visual Basic, 17–21 Startup form, 290 StateChanged event, 466–468 Statements With, 273 Call, 666–667 ChDir, 371 ChDrive, 371 Close, 348 Debug.Print, 649 Declare, 667–669 Dim, 67, 127, 148 For Each...Next, 156 End, 34, 56–57, 501 Enum...End Enum, 78 On Error, 633–635 On Error Resume Next, 639–640 Exit For, 89 Input #, 350–352 Line Input, 279 Load, 303 On Local Error, 225 MkDir, 303 Name, 373 Open, 346 Put, 362–364, 365 RaiseEvent, 449 Resume, 635–636 RmDir, 370 traditional file management, 370–374 Type...End Type, 71–72 Unload, 500 With...End With, 92–93 Write #, 349–351 Static arrays, 75 Status parameters for sound and video devices, 419 StatusUpdate event, 430 Step commands, 656 Step keyword, 333 StillExecuting property, 478, 487 Stop bit parameter, 401 Storing, composite images, 321–324 String concatenator operators, 80–81 String manipulation operators, 80–81 String processing functions, 293 String Variables, 68–70 Structured English Query Language. See SEQUEL. Structured programming, 108 Structured Query Language. See SQL. Structures, 70–72 Style property, 578–579 SubFolders collection, 377 SubFolders property, 378 SubItems property, 180 Sub procedures, 108–109 Subtraction operator (-), 80 Subtractive primary colors, 325 SuperString class demonstration project, 147–151 Surrogate keys, 554 Symbolic constants, 76–77 Syntax checking, automatic, 112 Syntax errors, 112, 631–632 T Tables database, 492 dependent, 539 primary, 539 Table-type Recordset, 520 Tab order, 581 Tabs Buttons, 577–579 Toolbar Control properties, 575–576 Tabs collection, 174 TabStrip control, 173–177 TabStrip properties, 174–176 Tag property, 165, 215, 216–217, 578 Terminate event, 447 Termination procedure, 190 TestExpression, 87 Text aligning, 670–671 colors, 54, 57–58 displaying, 334–336 in sequential files, 353–361 Text Box controls, 23, 26–29, 47, 549 adding, 26–27 changing properties, 27–29, 49–51 Text boxes, 102–103 Text box project, 49–60 TextChanged flag, 277 Text files, 264 access, traditional, 353–355 Text property, 27–28, 50–51 TextStream object, 356–359 Three-tier client/server models, 621 Threshold property, 406 TimeFormat property, 427–428 Timer control, 320, 422 Toolbar control, 575–579 relationship to buttons, 576–577 Toolbar Control properties, 575–576 Toolbars adding buttons, 579–581 creating, 574 Form Editor, 46 Toolbox window, 20 ToolTipText property, 578 Topic of conversation, 201 Top property, 298 TotalSize property, 376 Traditional text file access, 353–355 Transaction-processing applications, 542–543 Transferring data, using DDE, 219–225 Trapping errors, 633–635 TreeView control, 161–173 demonstration program, 167–173 Tuples, 538 Twips, 41 Screen object properties, 297 Two-tier client/server models, 620–621 .TXT file extension, 264 Type...End Type statement, 71–72 Type Library, 137–138 TypeOf keyword, 158–159 Type property, 383 U Unicode, 357 Unload event, 501 Unload statement, 500 UpdateInterval property, 430 Update method, 240–241 UpdateOptions property, 240–241 URL property, 487 UserControl Designer, 439–440 UserControl object, 439–440 User-defined data types, 70–72 User-defined errors, 641–644 User events, 34 See also Events. User input. See Events. Username property, 475–476, 487 V Validate event, 571–573, 597, 600 Validation methods, 595–599 ValidationOnSet property, 566 Validation properties, 566 ValidationRule property, 566 ValidationText property, 566 Value property, 53, 144–145, 578 Variable-length strings, 69 Variables, 64–70 changing values, 655 declaring, 67–70, 127, 187 determining type, 66 mvarLength, 142 mvarValue, 142 naming, 65–67 numeric, 64–65 other types, 70 out of scope, 127 public, 100–102 scope, 127–128 string, 68–70 Variant array, 99 Variant data type, 97–98 Variant data type, 643–644 Variant variable type, 70 VbCFLink constant, 215 VbCRLF constant, 280 VbCRLF defined constant, 639 .VBP file extension, 40 VCM (Visual Component Manager), 626–627 Viewing code, 33 code associated with objects, 35 objects, 33 Views full-module, 35 procedure, 35 VisData. See Visual Data Manager. Visible property, 270, 578, 607 vs. Show and Hide methods, 291 Visual Component Manager, 626–627 Visual Data Manager (VisData), 509, 511, 560–563, 569 Visual interface, 22 VolumeName property, 376 W Wait property, 428 Watches windows, 652–654 Watch expressions, 650–652 context, 653–654 types of, 652 WebBrowser control, 487–488 While...Wend loop, 91 Width property, 298–299 Windows API (Applications Programming Interface), 665–680 accessing, 666–668 demonstration project, 670–675 Windows API functions, declaring as procedures, 669–670 Windows API procedures, 666–670 Windows (operating system) clipboard, copying to, 123 common controls, 159–181 global constants related to DDE, 208 messages, 11–12 registry OLE server information, 232–233 registry and objects, 135 Windows (screen) See also Forms. Code Editing, 33, 35 Form Design, 20 Form Layout, 21 Main, 19, 20, 21 Project Explorer, 20 Properties, 20–21, 25–26 Toolbox, 20 WindowStyle argument, 219–220 With...End With statement, 92–93 With statement, 273 Wizard, Application, 128–129 .WMF file extension, 309 Word length parameter, 401 Workstations, 618 Wrappable property, 576 WriteBlankLines(n) method, 359 WriteLine(s) method, 359 WriteProperties event, 447 Write(s) method, 359 Write # statement, 349–351 Writing data to random access files, 362–363 X Xor (logical operator), 84
Previous | Table of Contents | Next

| Products | Contact Us | About Us | Privacy | Ad Info | Home Use of this site is subject to cert